Consider the following performance
For example, avoid using ToText( ) to convert a numeric database field to a string database field.
For example, a record selection of {@ExtendedPrice > 1000}
where @ExtendedPrice = (Orders * Quantity)
can't be pushed down. However, if @ExtendedPrice
is replaced with an SQL Expression field, then it will be pushed down.
For additional details, see Strategies for writing efficient record selection formulas and Incorporating parameter fields into record selection formulas.
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |